﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_SMS_SendBufferList]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_SMS_SendBufferList];
GO
CREATE PROCEDURE [dbo].[sproc_SMS_SendBufferList]
    
    
/*

===================================================
功能:    得到待发送消息列表
参数:
返回值:
    
===================================================

*/
AS

SET NOCOUNT ON
SELECT *  FROM  UDS_SMS_MobileMsgSendBuffer ORDER BY MsgID DESC

SET NOCOUNT OFF